﻿CREATE TABLE [dbo].[Funktion] (
    [Id]                UNIQUEIDENTIFIER NOT NULL,
    [ValId]             UNIQUEIDENTIFIER NOT NULL,
    [Beskrivning]       NVARCHAR (50)    NOT NULL,
    [PublikBeskrivning] NVARCHAR (50)    NOT NULL,
    [Arvode]            INT              NOT NULL,
    [FastErsattning]    BIT              NOT NULL,
    [Skapad]            DATETIME         NOT NULL,
    [SkapadAv]          NVARCHAR (50)    NOT NULL,
    [Andrad]            DATETIME         NULL,
    [AndradAv]          NVARCHAR (50)    NULL,
    [LISAIntegration]   BIT              CONSTRAINT [LISA_DefaultVal] DEFAULT ((0)) NOT NULL,
    [ArkivIntegration]  BIT              CONSTRAINT [Arkiv_DefaultVal] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_Funktion] PRIMARY KEY CLUSTERED ([Id] ASC, [ValId] ASC)
);





